Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2772
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.7 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qtt_invoices` and 3 other fields	High correlation
`qtt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`unique_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`total_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_unique_basket_size`	High correlation
`avg_recency` is highly correlated with `daily_purchase_rate`	High correlation
`daily_purchase_rate` is highly correlated with `avg_recency`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `unique_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtt_invoices` and 1 other fields	High correlation
`qtt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`unique_products` is highly correlated with `qtt_invoices`	High correlation
`total_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_basket_size` is highly correlated with `total_products`	High correlation
`gross_revenue` is highly correlated with `qtt_invoices` and 1 other fields	High correlation
`qtt_invoices` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`unique_products` is highly correlated with `avg_unique_basket_size`	High correlation
`total_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_recency` is highly correlated with `daily_purchase_rate`	High correlation
`daily_purchase_rate` is highly correlated with `avg_recency`	High correlation
`avg_basket_size` is highly correlated with `total_products`	High correlation
`avg_unique_basket_size` is highly correlated with `unique_products`	High correlation
`df_index` is highly correlated with `avg_recency`	High correlation
`gross_revenue` is highly correlated with `qtt_invoices` and 4 other fields	High correlation
`qtt_invoices` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`unique_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`total_products` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_ticket` is highly correlated with `total_prod_returned`	High correlation
`avg_recency` is highly correlated with `df_index`	High correlation
`total_prod_returned` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`daily_purchase_rate` is highly skewed (γ1 = 46.06904053)	Skewed
`total_prod_returned` is highly skewed (γ1 = 20.73295106)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`total_prod_returned` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2022-08-09 21:43:38.542943
Analysis finished	2022-08-09 21:44:27.064153
Duration	48.52 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	2772
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2250.265152

Minimum	0
Maximum	5694
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	181.55
Q1	899.75
median	2060.5
Q3	3410.5
95-th percentile	4957.95
Maximum	5694
Range	5694
Interquartile range (IQR)	2510.75

Descriptive statistics

Standard deviation	1526.176049
Coefficient of variation (CV)	0.6782205414
Kurtosis	-0.9562509049
Mean	2250.265152
Median Absolute Deviation (MAD)	1240.5
Skewness	0.3797379825
Sum	6237735
Variance	2329213.334
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2909	1	< 0.1%
2895	1	< 0.1%
2896	1	< 0.1%
2899	1	< 0.1%
2900	1	< 0.1%
2904	1	< 0.1%
2905	1	< 0.1%
2906	1	< 0.1%
2907	1	< 0.1%
Other values (2762)	2762	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5694	1	< 0.1%
5684	1	< 0.1%
5678	1	< 0.1%
5653	1	< 0.1%
5647	1	< 0.1%
5636	1	< 0.1%
5635	1	< 0.1%
5619	1	< 0.1%
5618	1	< 0.1%
5609	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2772
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.114

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.55
Q1	13814.75
median	15240.5
Q3	16780.5
95-th percentile	17950.45
Maximum	18287
Range	5940
Interquartile range (IQR)	2965.75

Descriptive statistics

Standard deviation	1715.439416
Coefficient of variation (CV)	0.1122294159
Kurtosis	-1.207577693
Mean	15285.114
Median Absolute Deviation (MAD)	1484.5
Skewness	0.01689580368
Sum	42370336
Variance	2942732.389
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14482	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
Other values (2762)	2762	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2758
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2830.005032

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.539
Q1	628.3675
median	1169.4
Q3	2421.64
95-th percentile	7405.9275
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1793.2725

Descriptive statistics

Standard deviation	10438.70669
Coefficient of variation (CV)	3.688582377
Kurtosis	376.9967288
Mean	2830.005032
Median Absolute Deviation (MAD)	687.31
Skewness	17.22344489
Sum	7844773.95
Variance	108966597.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
2053.02	2	0.1%
1314.45	2	0.1%
331	2	0.1%
Other values (2748)	2752	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.58297258

Minimum	0
Maximum	372
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.35191887
Coefficient of variation (CV)	1.207994486
Kurtosis	3.450178388
Mean	56.58297258
Median Absolute Deviation (MAD)	23
Skewness	1.901084359
Sum	156848
Variance	4671.984813
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
3	85	3.1%
2	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2025	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

qtt_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.055916306

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.074222455
Coefficient of variation (CV)	1.498406186
Kurtosis	183.8507135
Mean	6.055916306
Median Absolute Deviation (MAD)	2
Skewness	10.62222952
Sum	16787
Variance	82.34151316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	779	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	779	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

unique_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	340
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.36147186

Minimum	1
Maximum	1786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	29
median	57
Q3	105
95-th percentile	239.45
Maximum	1786
Range	1785
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	98.7487723
Coefficient of variation (CV)	1.184585278
Kurtosis	80.60248651
Mean	83.36147186
Median Absolute Deviation (MAD)	33
Skewness	6.351341471
Sum	231078
Variance	9751.320031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	38	1.4%
24	37	1.3%
26	36	1.3%
33	35	1.3%
25	34	1.2%
28	34	1.2%
18	32	1.2%
30	32	1.2%
15	30	1.1%
31	29	1.0%
Other values (330)	2435	87.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	0.7%
2	13	0.5%
3	17	0.6%
4	18	0.6%
5	22	0.8%
6	19	0.7%
7	21	0.8%
8	24	0.9%
9	23	0.8%
10	20	0.7%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%
817	1	< 0.1%
717	1	< 0.1%
714	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

total_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1637
Distinct (%)	59.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1665.883478

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	119.55
Q1	330
median	703.5
Q3	1478
95-th percentile	4568.1
Maximum	196844
Range	196842
Interquartile range (IQR)	1148

Descriptive statistics

Standard deviation	5883.560113
Coefficient of variation (CV)	3.531795706
Kurtosis	488.0670946
Mean	1665.883478
Median Absolute Deviation (MAD)	452
Skewness	18.24506239
Sum	4617829
Variance	34616279.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
219	7	0.3%
200	7	0.3%
300	7	0.3%
493	7	0.3%
1200	7	0.3%
272	7	0.3%
260	7	0.3%
Other values (1627)	2696	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	2770
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.50911923

Minimum	2.150588235
Maximum	1687.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.852205466
Q1	12.41296977
median	17.93606578
Q3	25.00599826
95-th percentile	86.4856545
Maximum	1687.2
Range	1685.049412
Interquartile range (IQR)	12.59302849

Descriptive statistics

Standard deviation	67.31774107
Coefficient of variation (CV)	2.206479333
Kurtosis	182.3411047
Mean	30.50911923
Median Absolute Deviation (MAD)	6.32595137
Skewness	10.92302982
Sum	84571.27852
Variance	4531.678263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
6.269700855	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
17.98461538	1	< 0.1%
Other values (2760)	2760	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%
602.4531323	1	< 0.1%
591.7066667	1	< 0.1%

avg_recency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1155
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.74240252

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.125
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.875

Descriptive statistics

Standard deviation	66.49989571
Coefficient of variation (CV)	0.8445245964
Kurtosis	3.687351115
Mean	78.74240252
Median Absolute Deviation (MAD)	30
Skewness	1.830983679
Sum	218273.9398
Variance	4422.23613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
49	16	0.6%
31	16	0.6%
91	16	0.6%
21	15	0.5%
35	15	0.5%
42	15	0.5%
28	14	0.5%
Other values (1145)	2609	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

daily_purchase_rate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04972001241

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008746355685
Q1	0.01577911314
median	0.0243902439
Q3	0.04166666667
95-th percentile	0.1153846154
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.02588755353

Descriptive statistics

Standard deviation	0.3377158337
Coefficient of variation (CV)	6.792352161
Kurtosis	2294.878341
Mean	0.04972001241
Median Absolute Deviation (MAD)	0.01069454458
Skewness	46.06904053
Sum	137.8238744
Variance	0.1140519843
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.02941176471	14	0.5%
0.03448275862	14	0.5%
0.02564102564	13	0.5%
0.07692307692	13	0.5%
0.02127659574	13	0.5%
Other values (1215)	2624	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

total_prod_returned
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	203
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.73448773

Minimum	0
Maximum	8004
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	95.45
Maximum	8004
Range	8004
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	235.4560695
Coefficient of variation (CV)	7.419564212
Kurtosis	569.4476922
Mean	31.73448773
Median Absolute Deviation (MAD)	0
Skewness	20.73295106
Sum	87968
Variance	55439.56066
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (193)	651	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%
1535	2	0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1936
Distinct (%)	69.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229.3617361

Minimum	1
Maximum	3868.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.325
median	172
Q3	278.1214286
95-th percentile	583.675
Maximum	3868.65
Range	3867.65
Interquartile range (IQR)	174.7964286

Descriptive statistics

Standard deviation	237.6557625
Coefficient of variation (CV)	1.036161335
Kurtosis	45.20826542
Mean	229.3617361
Median Absolute Deviation (MAD)	81
Skewness	5.146920468
Sum	635790.7323
Variance	56480.26147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
136	7	0.3%
82	7	0.3%
105	7	0.3%
73	7	0.3%
197	7	0.3%
208	7	0.3%
Other values (1926)	2694	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.933333	1	< 0.1%
1858	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	897
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.14667573

Minimum	0.2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.545454545
median	13.5
Q3	22
95-th percentile	45.1125
Maximum	177
Range	176.8
Interquartile range (IQR)	14.45454545

Descriptive statistics

Standard deviation	14.2623174
Coefficient of variation (CV)	0.8317832347
Kurtosis	10.01065379
Mean	17.14667573
Median Absolute Deviation (MAD)	6.666666667
Skewness	2.246708129
Sum	47530.58512
Variance	203.4136977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	34	1.2%
13	33	1.2%
9	32	1.2%
16	32	1.2%
7	32	1.2%
12	30	1.1%
14	29	1.0%
6	29	1.0%
17	29	1.0%
18.5	29	1.0%
Other values (887)	2463	88.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
177	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%
93.33333333	1	< 0.1%
89.625	1	< 0.1%
87	1	< 0.1%
85.66666667	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtt_invoices	unique_products	total_products	avg_ticket	avg_recency	daily_purchase_rate	total_prod_returned	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	21.0	1733.0	18.152222	1.000000	17.000000	40.0	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	105.0	1390.0	18.904035	52.833333	0.028302	35.0	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	114.0	5028.0	28.902500	26.500000	0.040323	50.0	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	24.0	439.0	33.866071	92.666667	0.017921	0.0	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	1.0	80.0	292.000000	20.000000	0.073171	22.0	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	61.0	2102.0	45.326471	26.769231	0.040115	29.0	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	148.0	3621.0	17.219786	19.263158	0.057221	399.0	172.428571	7.047619
7	7	17809	5411.91	16.0	12.0	46.0	2057.0	88.719836	39.666667	0.033520	41.0	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	567.0	38194.0	25.543464	4.191011	0.243316	474.0	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	34.0	613.0	29.934776	47.666667	0.024390	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtt_invoices	unique_products	total_products	avg_ticket	avg_recency	daily_purchase_rate	total_prod_returned	avg_basket_size	avg_unique_basket_size
2762	5609	17290	525.24	3.0	2.0	92.0	404.0	5.149412	13.0	0.142857	0.0	202.000000	46.000000
2763	5618	14785	77.40	10.0	2.0	2.0	84.0	25.800000	5.0	0.333333	0.0	42.000000	1.000000
2764	5619	17254	272.44	4.0	2.0	100.0	252.0	2.432500	11.0	0.166667	0.0	126.000000	50.000000
2765	5635	17232	421.52	2.0	2.0	30.0	203.0	11.708889	12.0	0.153846	0.0	101.500000	15.000000
2766	5636	17468	137.00	10.0	2.0	5.0	116.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
2767	5647	13596	697.04	5.0	2.0	133.0	406.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000
2768	5653	14893	1237.85	9.0	2.0	72.0	799.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000
2769	5678	14126	706.13	7.0	3.0	14.0	508.0	47.075333	3.0	0.750000	50.0	169.333333	4.666667
2770	5684	13521	1092.39	1.0	3.0	312.0	733.0	2.511241	4.5	0.300000	0.0	244.333333	104.000000
2771	5694	15060	301.84	8.0	4.0	80.0	262.0	2.515333	1.0	2.000000	0.0	65.500000	20.000000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows